package com.easipass.lgsa.portRelease.util;

import com.easipass.lgsa.portRelease.model.PortReleaseInexpRltModel;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import javax.persistence.EntityManager;
import javax.persistence.Query;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@Component
public class SqlUtil {

    @Autowired
    private EntityManager entityManager;

    /*public List<SasPassportBscModel> getCheckedPassport(Date startTime, Date endTime) {
        String sql = "select distinct bsc.* from SAS_PASSPORT_BSC bsc, SAS_PASSPORT_STATUS status where bsc.ID = status.PID and status.OPT_STATUS = '55' and status.OPT_TIME between :startTime and :endTime";
        Query query = entityManager.createNativeQuery(sql, SasPassportBscModel.class);
        query.setParameter("startTime", startTime);
        query.setParameter("endTime", endTime);
        return query.getResultList();
    }*/



}
